When using the OLAP Analyzer in SAS Enterprise Guide, cube view actions such as adding a dimension or expanding a dimension level have slow performance. By default, when more than one dimension is displayed on either the row or column axis, SAS Enterprise Guide uses the CROSSJOIN function with NON EMPTY specifiers.

Here is an example of a default query generated by the SAS Enterprise Guide cube viewer:

In contrast, the NONEMPTYCROSSJOIN function usually has better performance. Here is an example of the same query generated by the SAS Enterprise Guide cube viewer with the updated configuration option:

Click the Hot Fix tab in this note to access the hot fix for this issue. After the hot fix is applied, you can set a property so that SAS Enterprise Guide uses the NONEMPTYCROSSJOIN function, which should improve performance. To use the property, perform the following steps. (These steps are also in the post-installation instructions for the hot fix.)

1. Navigate to the SAS Enterprise Guide installation directory. For example, 

If you are SAS Enterprise Guide 32-bit, navigate to .\Program Files (x86)\SASHome\x86\SASEnterpriseGuide\7.1

If you are SAS Enterprise Guide 64-bit, navigate to .\Program Files\SASHome\SASEnterpriseGuide\7.1

2. Create a copy of SEGuide.exe.config and rename the copy SEGuide.exe.config.ORIG.
3. Open SEGuide.exe.config in a text editor.
4. Add the following code to the end of the file, immediately before </configuration>:

5. Save SEGuide.exe.config.
6. Start a new session of SAS Enterprise Guide.

Operating System and Release Information

A fix for this issue for SAS Enterprise Guide 7.15 is available at: